use ATE
go




IF OBJECT_ID ( 'PIMTestItem_selectbySNDT', 'P' ) IS NOT NULL 
    DROP PROCEDURE PIMTestItem_selectbySNDT;
GO
CREATE PROCEDURE PIMTestItem_selectbySNDT
	@ProductSN nvarchar(50),  
	@TestTime datetime 
AS    
    SET NOCOUNT ON;
    select ProductSN,TestTime,TopoAlias,InterceptOrder,InputPower1,InputPower2,InputF1,InputF2,OutputF,TestValue,HighSpec,IsPass
	from PIMTestItem
	where ProductSN=@ProductSN and TestTime=@TestTime
GO



